ImportService

The ImportService section of the web.config file allows you to configure the policies of the import service.

Attribute

Use

errorMaximumPercent

The percentage of error records that are allowed before aborting an import. If specified, the value must be an integer between zero and 100. If not specified, the system defaults to 10%. The actual number of errors that will cause an abort is also subject to the value of the errorMinimumCount attribute. An import will not abort unless both the errorMaximumPercent and errorMinimumCount are met.

errorMinimumCount

The minimum number of errors before aborting an import. If specified, value must be an integer that is greater than or equal to zero. If not specified, the system defaults to 100. The actual number of errors that will cause an abort is also subject to the value of the errorMaximumPercent attribute. An import will not abort unless both the errorMaximumPercent and errorMinimumCount are met.

startupType

The start mode of the import service when the application starts. If not specified, the system defaults to "Automatic". If specified, the value must be "Automatic", "Manual", or "Disabled":

Automatic - The service is to be started by the application, at system start-up.

Manual - The service is started only manually, by a user or by an application.

Disabled - The service is disabled, so it cannot be started by a user or application.

integrationType

The type of the integrating system. The valid values are 'DATAFLO', 'ECLIPSE', 'PRELUDE', or ''.

isRemoveImportTable

Specifies whether temporary import tables are removed after an import is complete. If True, all import temporary tables are removed before and after import processing. If False, all import temporary tables are only removed prior to import processing but they are not removed afterward. This option is used primarily as a debugging aid by providing access to the import data. If not specified, the default value for this attribute is True, meaning import temporarily tables are removed after processing.

importOrderList

Specifies the precedence of imports which controls processing order. This is a comma-separated list of import names, all of which must be valid ExportName in KsExportColumns. The system will only process imports specified in this list. If not specified, the system defaults to the following list:

CATEGORY,SPECIAL_CHARGES,COMPETITORS,MFG_ITEMS,

ITEM_XPROPS,COMPETITOR_XREFS,BOMS,

BASE_PRICES,WAREHOUSE_ITEMS,OPTIONS,RULES,MODELS,

INVENTORY,ATP,SALES_TAX,FREIGHT,CURRENCY,

EXCHG_RATES,REGIONS,CLASSIFICATIONS,DISCOUNT_CLASSES,CUSTOMERS,ENDUSERS,VENDORS,SHIP_ADDRS,PRICE_ADJS,

DEPARTMENTS,CONTACTS,CUST_PARTS,RMA_TYPES,

FAILURE_CODES,WARRANTY_CODES,SERVICE_TYPES,

SERVICE_LOGS,SERVICE_CHARGES,ORDERS,RMAS,SHIPMENTS,

RMA_RECEIPTS,SERIALHIST,INVOICES,QUOTES,COMMISSIONS,

VEHICLE_SEARCH,REPQUOTA,GEO_RESTRICTIONS

importFileRegex

The regular expression to use when parsing import file names. If specified, the value must be a valid XML-encoded regular expression that includes the importName and importMode capture groups. If not specified, the system uses the following regular expression: ^(?<source>[^_]*)_(?<sequence>[^_]*)_(?<integrationId>[^_]*)_(?<importName>[^\.]+).(?<importMode>net|full)$

This expression parses file names such as "ECLIPSE_00012081_KS_ORDERS.net" and "___ORDERS.net"

importDirectoryVirtualPath

The virtual path of the import drop directory. The import services monitors this folder for files to import. If not specified, the system defaults to "~/ks_data/". If specified, the value must be a valid virtual path, and the directory must exist in the local file system.

importJobsDirectoryVirtualPath

The virtual path of the import jobs directory. When the import services detects a file to import, the file is moved to this folder for handling. If not specified, the system defaults to "~/ks_data/ImportJobs/". If specified, the value must be a valid virtual path, and the directory must exist in the local file system.

Example Usage

<ImportService errorMinimumCount="100" errorMaximumPercent="10" />